/****** Object:  Stored Procedure dbo.asi_ActiveSourceCodeBySegmentationJob    Script Date: 7/3/2003 4:58:02 PM ******/
CREATE PROC [dbo].[asi_ActiveSourceCodeBySegmentationJob]

@jobKey uniqueidentifier

AS
SELECT Count(*)
FROM
    vBoSourceList sl INNER JOIN vBoSourceCode sc
    ON sl.SourceCodeKey = sc.SourceCodeKey
WHERE
    EXISTS
        (SELECT 1
        FROM SegmentDefinition sd INNER JOIN SegmentationJob sj
        ON sd.SegmentationJobKey = sj.SegmentationJobKey
        WHERE
        CHARINDEX(CAST(sd.SegmentDefinitionKey AS varchar(36)), sl.OriginListKeys) <> 0
        AND sj.SegmentationJobKey = @jobKey)
    AND sc.SourceCodeStatusCode = 0

GO